SherbyNet - /page/wikibook/entry.mu

Micron Document

<!DOCTYPE html>

<title>Query plan</title>

</head>

Query plan

</h1>

</header>

A query plan (or query execution plan) is a sequence of steps used to <a href="Data_access" title="Data access">access data</a> in a <a href="SQL" title="SQL">SQL</a> <a href="Relational_database_management_system" class="mw-redirect" title="Relational database management system">relational database management system</a>. This is a specific case of the <a href="Relational_model" title="Relational model">relational model</a> concept of access plans.

Since <a href="SQL" title="SQL">SQL</a> is <a href="Declarative_programming" title="Declarative programming">declarative</a>, there are typically many alternative ways to execute a given query, with widely varying performance. When a <a href="Information_retrieval" title="Information retrieval">query</a> is submitted to the database, the <a href="Query_optimizer" class="mw-redirect" title="Query optimizer">query optimizer</a> evaluates some of the different, correct possible plans for executing the query and returns what it considers the best option. Because query optimizers are imperfect, database users and administrators sometimes need to manually examine and tune the plans produced by the optimizer to get better performance.

<div class="mw-heading mw-heading2"><h2 id="Generating_query_plans">Generating query plans</h2></div>

A given database management system may offer one or more mechanisms for returning the plan for a given query. Some packages feature tools which will generate a graphical representation of a query plan. Other tools allow a special mode to be set on the connection to cause the DBMS to return a textual description of the query plan. Another mechanism for retrieving the query plan involves querying a virtual database table after executing the query to be examined. In Oracle, for instance, this can be achieved using the EXPLAIN PLAN statement.

<div class="mw-heading mw-heading3"><h3 id="Graphical_plans">Graphical plans</h3></div>

The <a href="SQL_Server_Management_Studio" title="SQL Server Management Studio">Microsoft SQL Server Management Studio</a> tool, which ships with <a href="Microsoft_SQL_Server" title="Microsoft SQL Server">Microsoft SQL Server</a>, for example, shows this graphical plan when executing this two-table join example against an included sample database:

<div class="mw-highlight mw-highlight-lang-tsql mw-content-ltr" dir="ltr"><pre>SELECT *

FROM HumanResources.Employee AS e

INNER JOIN Person.Contact AS c

ON e.ContactID = c.ContactID

ORDER BY c.LastName

</pre></div>

The UI allows exploration of various attributes of the operators involved in the query plan, including the operator type, the number of rows each operator consumes or produces, and the expected cost of each operator's work.

<div class="mw-heading mw-heading3"><h3 id="Textual_plans">Textual plans</h3></div>

The textual plan given for the same query in the screenshot is shown here:

<div class="mw-highlight mw-highlight-lang-tsql mw-content-ltr mw-highlight-lines" dir="ltr"><pre>StmtText

----

|--Sort(ORDER BY:([c].[LastName] ASC))

|--Nested Loops(Inner Join, OUTER REFERENCES:([e].[ContactID], [Expr1004]) WITH UNORDERED PREFETCH)

|--Clustered Index Scan(OBJECT:([AdventureWorks].[HumanResources].[Employee].[PK_Employee_EmployeeID] AS [e]))

|--Clustered Index Seek(OBJECT:([AdventureWorks].[Person].[Contact].[PK_Contact_ContactID] AS [c]),

SEEK:([c].[ContactID]=[AdventureWorks].[HumanResources].[Employee].[ContactID] as [e].[ContactID]) ORDERED FORWARD)

</pre></div>

It indicates that the query engine will do a scan over the primary key index on the Employee table and a matching seek through the primary key index (the ContactID column) on the Contact table to find matching rows. The resulting rows from each side will be shown to a nested loops join operator, sorted, then returned as the <a href="Result_set" title="Result set">result set</a> to the connection.

In order to tune the query, the user must understand the different operators that the database may use, and which ones might be more efficient than others while still providing semantically correct query results.

<div class="mw-heading mw-heading2"><h2 id="Database_tuning">Database tuning</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .hatnote{font-style:italic}.mw-parser-output div.hatnote{padding-left:1.6em;margin-bottom:0.5em}.mw-parser-output .hatnote i{font-style:normal}.mw-parser-output .hatnote+link+.hatnote{margin-top:-0.5em}@media print{body.ns-0 .mw-parser-output .hatnote{display:none!important}}

/* end https://en.wikipedia.org/ */

</style><div role="note" class="hatnote navigation-not-searchable">Main article: <a href="Database_tuning" title="Database tuning">Database tuning</a></div>

Reviewing the query plan can present opportunities for new <a href="Index_(database)" class="mw-redirect" title="Index (database)">indexes</a> or changes to existing indexes. It can also show that the database is not properly taking advantage of existing indexes (see <a href="Query_optimizer" class="mw-redirect" title="Query optimizer">query optimizer</a>).

<div class="mw-heading mw-heading2"><h2 id="Query_tuning">Query tuning</h2></div>

<div role="note" class="hatnote navigation-not-searchable">Main article: <a href="Query_optimizer" class="mw-redirect" title="Query optimizer">Query optimizer</a></div>

A query optimizer will not always choose the most efficient query plan for a given query. In some databases the query plan can be reviewed, problems found, and then the <a href="Query_optimizer" class="mw-redirect" title="Query optimizer">query optimizer</a> gives <a href="Hint_(SQL)" title="Hint (SQL)">hints</a> on how to improve it. In other databases, alternatives to express the same query (other queries that return the same results) can be tried. Some query tools can generate embedded hints in the query, for use by the optimizer.

Some databases - like Oracle - provide a plan table for query tuning. This plan table will return the cost

and time for executing a query. Oracle offers two optimization approaches:

<ol><li>CBO or Cost Based Optimization</li>

<li>RBO or Rule Based Optimization</li></ol>

RBO is slowly being deprecated. For CBO to be used, all the tables referenced by the query must be analyzed. To analyze a table, a DBA can launch code from the DBMS_STATS package.

Other tools for query optimization include:

<ol><li>SQL Trace<a href="#cite_note-1">[1]</a></li>

<li>Oracle Trace and TKPROF <a href="#cite_note-2">[2]</a></li>

<li>Microsoft SMS (SQL) Execution Plan<a href="#cite_note-3">[3]</a></li>

<li>Tableau Performance Recording (all DB)<a href="#cite_note-4">[4]</a></li></ol>

/* start https://en.wikipedia.org/ */

.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist.inline,.mw-parser-output .hlist.inline dl,.mw-parser-output .hlist.inline ol,.mw-parser-output .hlist.inline ul,.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li{display:none}.mw-parser-output .hlist dt::after{content:": "}.mw-parser-output .hlist dd::after,.mw-parser-output .hlist li::after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child::after,.mw-parser-output .hlist dt:last-child::after,.mw-parser-output .hlist li:last-child::after{content:none}.mw-parser-output .hlist dd dd:first-child::before,.mw-parser-output .hlist dd dt:first-child::before,.mw-parser-output .hlist dd li:first-child::before,.mw-parser-output .hlist dt dd:first-child::before,.mw-parser-output .hlist dt dt:first-child::before,.mw-parser-output .hlist dt li:first-child::before,.mw-parser-output .hlist li dd:first-child::before,.mw-parser-output .hlist li dt:first-child::before,.mw-parser-output .hlist li li:first-child::before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child::after,.mw-parser-output .hlist dd dt:last-child::after,.mw-parser-output .hlist dd li:last-child::after,.mw-parser-output .hlist dt dd:last-child::after,.mw-parser-output .hlist dt dt:last-child::after,.mw-parser-output .hlist dt li:last-child::after,.mw-parser-output .hlist li dd:last-child::after,.mw-parser-output .hlist li dt:last-child::after,.mw-parser-output .hlist li li:last-child::after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li::before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child::before,.mw-parser-output .hlist dt ol>li:first-child::before,.mw-parser-output .hlist li ol>li:first-child::before{content:" ("counter(listitem)"\a0 "}

/* end https://en.wikipedia.org/ */

</style><style data-mw-deduplicate="TemplateStyles:r1236075235">

/* start https://en.wikipedia.org/ */

.mw-parser-output .navbox{box-sizing:border-box;border:1px solid #a2a9b1;width:100%;clear:both;font-size:88%;text-align:center;padding:1px;margin:1em auto 0}.mw-parser-output .navbox .navbox{margin-top:0}.mw-parser-output .navbox+.navbox,.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox-group,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{padding:0.25em 1em;line-height:1.5em;text-align:center}.mw-parser-output .navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background-color:#fdfdfd}.mw-parser-output .navbox-list{line-height:1.5em;border-color:#fdfdfd}.mw-parser-output .navbox-list-with-group{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output tr+tr>.navbox-abovebelow,.mw-parser-output tr+tr>.navbox-group,.mw-parser-output tr+tr>.navbox-image,.mw-parser-output tr+tr>.navbox-list{border-top:2px solid #fdfdfd}.mw-parser-output .navbox-title{background-color:#ccf}.mw-parser-output .navbox-abovebelow,.mw-parser-output .navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background-color:#ddf}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background-color:#e6e6ff}.mw-parser-output .navbox-even{background-color:#f7f7f7}.mw-parser-output .navbox-odd{background-color:transparent}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em}body.skin--responsive .mw-parser-output .navbox-image img{max-width:none!important}@media print{body.ns-0 .mw-parser-output .navbox{display:none!important}}

/* end https://en.wikipedia.org/ */

</style></div><div role="navigation" class="navbox" aria-labelledby="Database_management_systems327" style="padding:3px"><table class="nowraplinks hlist mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><style data-mw-deduplicate="TemplateStyles:r1239400231">

/* start https://en.wikipedia.org/ */

.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw-parser-output .navbar-boxtext{word-spacing:0}.mw-parser-output .navbar ul{display:inline-block;white-space:nowrap;line-height:inherit}.mw-parser-output .navbar-brackets::before{margin-right:-0.125em;content:"[ "}.mw-parser-output .navbar-brackets::after{margin-left:-0.125em;content:" ]"}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbar a>span,.mw-parser-output .navbar a>abbr{text-decoration:inherit}.mw-parser-output .navbar-mini abbr{font-variant:small-caps;border-bottom:none;text-decoration:none;cursor:inherit}.mw-parser-output .navbar-ct-full{font-size:114%;margin:0 7em}.mw-parser-output .navbar-ct-mini{font-size:114%;margin:0 4em}html.skin-theme-clientpref-night .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}@media(prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}}@media print{.mw-parser-output .navbar{display:none!important}}

/* end https://en.wikipedia.org/ */

</style><div id="Database_management_systems327" style="font-size:114%;margin:0 4em"><a href="Database" title="Database">Database management systems</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Types</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Object_database" title="Object database">Object-oriented</a>

<ul><li><a href="Comparison_of_object_database_management_systems" title="Comparison of object database management systems">comparison</a></li></ul></li>

<li><a href="Relational_database" title="Relational database">Relational</a>

<li><a href="Comparison_of_relational_database_management_systems" title="Comparison of relational database management systems">comparison</a></li></ul></li>

<li><a href="Key%E2%80%93value_database" title="Key–value database">Key–value</a></li>

<li><a href="Column-oriented_DBMS" class="mw-redirect" title="Column-oriented DBMS">Column-oriented</a>

<li><a href="Document-oriented_database" title="Document-oriented database">Document-oriented</a></li>

<li><a href="Wide-column_store" title="Wide-column store">Wide-column store</a></li>

<li><a href="Graph_database" title="Graph database">Graph</a></li>

<li><a href="NoSQL" title="NoSQL">NoSQL</a></li>

<li><a href="NewSQL" title="NewSQL">NewSQL</a></li>

<li><a href="In-memory_database" title="In-memory database">In-memory</a>

<li><a href="Multi-model_database" title="Multi-model database">Multi-model</a>

<ul><li><a href="Comparison_of_multi-model_databases" title="Comparison of multi-model databases">comparison</a></li></ul></li>

<li><a href="Cloud_database" title="Cloud database">Cloud</a></li>

<li><a href="Blockchain-based_database" title="Blockchain-based database">Blockchain-based database</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Concepts</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Database" title="Database">Database</a></li>

<li><a href="Armstrong's_axioms" title="Armstrong's axioms">Armstrong's axioms</a></li>

<li><a href="Codd's_12_rules" title="Codd's 12 rules">Codd's 12 rules</a></li>

<li><a href="CAP_theorem" title="CAP theorem">CAP theorem</a></li>

<li><a href="Candidate_key" title="Candidate key">Candidate key</a></li>

<li><a href="Foreign_key" title="Foreign key">Foreign key</a></li>

<li><a href="PACELC_design_principle" title="PACELC design principle">PACELC design principle</a></li>

<li><a href="Superkey" title="Superkey">Superkey</a></li>

<li><a href="Surrogate_key" title="Surrogate key">Surrogate key</a></li>

<li><a href="Unique_key" title="Unique key">Unique key</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Objects</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Relation_(database)" title="Relation (database)">Relation</a>

<ul><li><a href="Table_(database)" title="Table (database)">table</a></li>

<li><a href="Column_(database)" title="Column (database)">column</a></li>

<li><a href="Database_transaction" title="Database transaction">Transaction</a></li>

<li><a href="Transaction_log" title="Transaction log">Transaction log</a></li>

<li><a href="Database_trigger" title="Database trigger">Trigger</a></li>

<li><a href="Database_index" title="Database index">Index</a></li>

<li><a href="Stored_procedure" title="Stored procedure">Stored procedure</a></li>

<li><a href="Cursor_(databases)" title="Cursor (databases)">Cursor</a></li>

<li><a href="Partition_(database)" title="Partition (database)">Partition</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Components</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Concurrency_control" title="Concurrency control">Concurrency control</a></li>

<li><a href="Data_dictionary" title="Data dictionary">Data dictionary</a></li>

<li><a href="Query_language" title="Query language">Query language</a></li>

<li><a href="Query_optimization" title="Query optimization">Query optimizer</a></li>

<li><a href="Query_Rewriting" class="mw-redirect" title="Query Rewriting">Query rewriting system</a></li>

</ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Functions</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Database_administration" title="Database administration">Administration</a></li>

<li><a href="Query_optimization" title="Query optimization">Query optimization</a></li>

<li><a href="Replication_(computing)#DATABASE" title="Replication (computing)">Replication</a></li>

<li><a href="Shard_(database_architecture)" title="Shard (database architecture)">Sharding</a></li></ul>

</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Related topics</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">

<ul><li><a href="Database_model" title="Database model">Database models</a></li>

<li><a href="Database_normalization" title="Database normalization">Database normalization</a></li>

<li>Database storage</li>

<li><a href="Distributed_database" title="Distributed database">Distributed database</a></li>

<li><a href="Federated_database_system" title="Federated database system">Federated database system</a></li>

<li><a href="Referential_integrity" title="Referential integrity">Referential integrity</a></li>

<li><a href="Relational_algebra" title="Relational algebra">Relational algebra</a></li>

<li><a href="Relational_calculus" title="Relational calculus">Relational calculus</a></li>

<li><a href="Relational_model" title="Relational model">Relational model</a></li>

<li><a href="Object%E2%80%93relational_database" title="Object–relational database">Object–relational database</a></li>

<li><a href="Transaction_processing" title="Transaction processing">Transaction processing</a></li></ul>

</div></td></tr><tr><td class="navbox-abovebelow" colspan="2"><div>

<ul><li> Category</li>

<li> <a href="Outline_of_databases" title="Outline of databases">Outline</a></li></ul>

</div></td></tr></tbody></table></div>

<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>

/* start https://en.wikipedia.org/ */

.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}

/* end https://en.wikipedia.org/ */

</style><div class="reflist">

/* start https://en.wikipedia.org/ */

.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}

/* end https://en.wikipedia.org/ */

</style><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?view=sql-server-ver15">"SQL Trace"</a>. Microsoft.com. Microsoft. Retrieved 30 March 2020.</cite>

</li>

<li id="cite_note-2"><a href="#cite_ref-2">^</a> <cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.oracle.com/cd/B10500_01/server.920/a96533/sqltrace.htm">"Using SQL Trace and TKPROF"</a>. Oracle.com. Retrieved 30 March 2020.</cite>

</li>

<li id="cite_note-3"><a href="#cite_ref-3">^</a> <cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://docs.microsoft.com/en-us/sql/relational-databases/performance/execution-plans?view=sql-server-ver15">"Execution Plans"</a>. Microsoft.com. Microsoft. Retrieved 30 March 2020.</cite>

</li>

<li id="cite_note-4"><a href="#cite_ref-4">^</a> <cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://help.tableau.com/current/pro/desktop/en-us/performance_tips.htm">"Optimize Workbook Performance"</a>. Tableau.com. Tableau Inc. Retrieved 30 March 2020.</cite>

</li>

</ol></div></div></div><div><div class="zim-footer">

This article is issued from <a class="external text" title="Last edited on 2025-06-23" href="https://en.wikipedia.org/wiki/?title=Query_plan&oldid=1296956659">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.

</div>

</div></div>

</div>

</main>

</div>

</body></html>